{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3","Sheet9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Dallan Delgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID","002-46-2565"," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-03-12T23:13:18.330"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-03-10T13:45:02.740","Dallan Delgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.46"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Macintosh (Intel) Version 11.0.1 (Build 20B29)"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Dallan Delgado","002-46-2565","2021-03-12T23:13:18.310","Dallan Delgado"]
["Start S01","Dallan Delgado","002-46-2565","2021-03-12T18:42:19.450"]
["Start S01","Dallan Delgado","002-46-2565","2021-03-10T13:45:02.730","Welcome to Microsoft Excel version 16.46 build 212 running on Macintosh (Intel) Version 11.0.1 (Build 20B29)!"]
["Starter Sheet","None",0,"2020-01-01","S01"]
[null,null,null,null,"Tom "]
[null,null,null,null,"C:\\Users\\Tom\\AppData\\Local\\Temp"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.0 build 13628 running on Windows (32-bit) NT 10.00!"]
[null,null,null,null,"S01"]
[null,null,null,null,"Dallan Delgado"]
[]
[null,null,null,null,"Welcome to Microsoft Excel version 16.46 build 212 running on Macintosh (Intel) Version 11.0.1 (Build 20B29)!"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals "]
[null,"Time period",null,null,"Fixed Costs"]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs"]
["Revenue: Donut"," ",3.5,null,"Coffee",{"$f":"C7","v":4}]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut",{"$f":"C8","v":3.5}]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
["2018-01-01",2475,null,{"$f":"B2/$C$13","v":0.80922020598332511},{"$f":"(D2+D14+D26)/3","v":0.72321735436293821},{"$f":"B2/E2","v":3422.2077015562741},1,null,"CLICK CELL J2 as output cell for regression","SUMMARY OUTPUT"]
["2018-02-01",2665.5,null,{"$f":"B3/$C$13","v":0.8715056400196175},{"$f":"(D3+D15+D27)/3","v":0.86924431576310479},{"$f":"B3/E3","v":3066.45663556623},2]
["2018-03-01",3597.5,null,1.1762301781919242,0.94544479054229813,3805.0873366561236,3,null,null,"Regression Statistics"]
["2018-04-01",3104,null,1.0148765734837339,0.9824600021075599,3159.4161526589796,4,null,null,"Multiple R",0.594717571902737]
["2018-05-01",2410,null,0.78796795814941967,0.97783484912260932,2464.6288707775575,5,null,null,"R Square",0.35368899032988721]
["2018-06-01",3592,null,1.1744319110675168,1.1135253751879617,3225.7908800629484,6,null,null,"Adjusted R Square",0.3346798429866486]
["2018-07-01",2740,null,0.89586398561386305,0.85653488363320396,3198.9356795109315,7,null,null,"Standard Error",274.43961293901913]
["2018-08-01",2683.5,null,0.87739087788131442,0.91873818666625706,2920.8538830168536,8,null,null,"Observations",36]
["2018-09-01",2697.5,null,0.88196828510707859,0.87974833353589554,3066.2178002181308,9]
["2018-10-01",3090,null,1.0102991662579697,1.0940468773930256,2824.3762345568562,10,null,null,"ANOVA"]
["2018-11-01",3342.5,"Put yearly average in below cell ",1.0928559751512179,1.2300957035048155,2717.2682503292031,11,null,null,null,"df","SS","MS","F","Significance F"]
["2018-12-01",4304.5,{"$f":"AVERAGE(B2:B13)","v":3058.5},1.4073892430930195,1.4091093281803309,3054.7665208906569,12,null,null,"Regression",1,1401368.9819619735,1401368.9819619735,18.606252239698239,1.3071566905954398E-4]
["2019-01-01",2135,null,{"$f":"B14/$C$25","v":0.64003597391890876},{"$f":"(D2+D14+D26)/3","v":0.72321735436293821},2952.0862395243007,13,null,null,"Residual",34,2560781.4391040336,75317.101150118629]
["2019-02-01",2971,null,{"$f":"B15/$C$25","v":0.89065427565015365},{"$f":"(D3+D15+D27)/3","v":0.86924431576310479},3417.911335309424,14,null,null,"Total",35,3962150.4210660071]
["2019-03-01",2811,null,0.84268905043843212,0.94544479054229813,2973.2037535345003,15]
["2019-04-01",3144,null,0.94251667541032746,0.9824600021075599,3200.130278337575,16,null,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["2019-05-01",3464.5,null,1.0385970171625571,0.97783484912260932,3543.0318351903934,17,null,null,"Intercept",2975.0745258649222,93.419589257699258,31.846367014718261,6.7207571133060488E-27,2785.2230785332463,3164.9259731965981,2785.2230785332463,3164.9259731965981]
["2019-06-01",3609.5,null,1.0820655025106798,1.1135253751879617,3241.5067320677099,18,null,null,"Time period",18.992438934211382,4.4030263708819373,4.3134965213499612,1.3071566905954474E-4,10.044412767605442,27.94046510081732,10.044412767605442,27.94046510081732]
["2019-07-01",2770,null,0.83039796147792855,0.85653488363320396,3233.9605227172556,19]
["2019-08-01",3077,null,0.9224312373529191,0.91873818666625706,3349.1587099097669,20]
["2019-09-01",3064,null,0.91853406280446681,0.87974833353589554,3482.8142131115301,21]
["2019-10-01",3744,null,1.1223862699542833,1.0940468773930256,3422.1568356572388,22]
["2019-11-01",4253.5,"Put yearly average in below cell ",1.2751255339878589,1.2300957035048155,3457.861032991852,23]
["2019-12-01",4985.5,{"$f":"AVERAGE(B14:B25)","v":3335.75},1.4945664393314846,1.4091093281803309,3538.0505261703729,24]
["2020-01-01",2584,null,{"$f":"B26/$C$37","v":0.72039588318658088},{"$f":"(D2+D14+D26)/3","v":0.72321735436293821},3572.9231114429945,25]
["2020-02-01",3033,null,{"$f":"B27/$C$37","v":0.84557303161954334},{"$f":"(D3+D15+D27)/3","v":0.86924431576310479},3489.2376573522324,26]
["2020-03-01",2932,null,0.81741514299653839,0.94544479054229813,3101.1858432455192,27]
["2020-04-01",3551,null,0.98998675742861797,0.9824600021075599,3614.3965071172797,28]
["2020-05-01",3970.5,null,1.1069395720558513,0.97783484912260932,4060.5016312955572,29]
["2020-06-01",3888.5,null,1.0840787119856887,1.1135253751879617,3492.0623154578998,30]
["2020-07-01",3025,null,0.84334270380782017,0.85653488363320396,3531.6716899710104,31]
["2020-08-01",3430.5,null,0.95639244476453777,0.91873818666625706,3733.9255620232225,32]
["2020-09-01",3008.5,null,0.83874265269614112,0.87974833353589554,3419.7279896037985,33]
["2020-10-01",4123,null,1.149455195966824,1.0940468773930256,3768.5770922582255,34]
["2020-11-01",4743,"Put yearly average in below cell ",1.3223056013753689,1.2300957035048155,3855.7975501305641,35,null,"Use the average seasonal Index  in the column for year 2018"]
["2020-12-01",4754,{"$f":"AVERAGE(B26:B37)","v":3586.9166666666665},1.3253723021164883,1.4091093281803309,{"$f":"B37/E37","v":3373.7623511009833},36,"Deseasonalized forecast","Seasonalized forecast"]
[null,null,null,null,null,null,37,{"$f":"$K$18+($K$19*G38)","v":3677.794766430743},{"$f":"H38*E2","v":2659.8450008679024},"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[null,null,null,null,null,null,38,{"$f":"$K$18+($K$19*G39)","v":3696.7872053649548},{"$f":"H39*E3","v":3213.4112648492605}]
[null,null,null,null,null,null,39,3715.7796442991662,3513.06450750576]
[null,null,null,null,null,null,40,3734.7720832333775,3669.2641887647201]
[null,null,null,null,null,null,41,3753.7645221675889,3670.5617651755479]
[null,null,null,null,null,null,42,3772.7569611018002,4201.0606106038767]
[null,null,null,null,null,null,43,3791.7494000360116,3247.7656311261162]
[null,null,null,null,null,null,44,3810.7418389702229,3501.0740469887405]
[null,null,null,null,null,null,45,3829.7342779044343,3369.2023488717223]
[null,null,null,null,null,null,46,3848.7267168386456,4210.6874464964321]
[null,null,null,null,null,null,47,3867.719155772857,4757.6647158794631]
[null,null,null,null,null,null,48,3886.7115947070688,{"$f":"H49*E13","v":5476.80156404838}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month ","Jan","Feb","March","April","May","June","July","August","September","October","November","December"]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2"]
["AVERAGE DEMAND"]
["Month "]
["Demand",null,null,null,null,null,null,null,null,null,null,null," "]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]

{"sheet":"Expected Values Pt3","index":6,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[]
[]
[null,null,null,null,null,null,null,"Decision Alternatives"]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,"Because:"]
[]
[]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]

{"sheet":"Sheet9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}